package com.esms.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.esms.po.Gassessment;
import com.esms.po.Satisfaction;

public interface SatisfactionMapper {
    
    List<Satisfaction> selectBypIdAnddId(@Param("eid")String eid,@Param("fEid")String fEid);
    List<Satisfaction> selectBypIdAnddIdAndfEid(@Param("eid")String eid,@Param("did")int did,@Param("fEid")String fEid);
    List<Satisfaction> selectBypIdAnddIdkz(Integer pId,Integer sjId,String e_account);
    List<Satisfaction> selectBypIdAnddIdAndfEidkz(Integer pId,Integer sjId,String fEid,String e_account);
	int updateBysId(Satisfaction satisfaction);
	int deleteSatisfaction(String aAuserid , String aDuserid);
	int insertSatisfaction(Gassessment gassessment);
	String selectByStat(int stat,int type);
}